Contents   Index

Import CSV File

This option will read points from a Comma Separated Value (CSV) file and will insert the points into the current job. The user can specify the data layout in a template file.
Refer also to Advanced Settings.
Note: See blottom of page for info on importing Non-ASCII Files

Template File
The Data layout is defined by the Template file. Click [...] to select a CSV template file.
Press 'New' to create a template file, or 'Edit' to edit the CSV template file.
See Create CSV Template for template file info.

Input CSV File
Enter the name of the raw data file to be read into the job.
This file will contain X,Y,Z points data in CSV format. Other text formats - see bottom of page

Start-End Line Number
When reading the raw data file, you may wish to skip over some data at the front of the file.
Enter the line number in the file at which to start reading data.
This will allow you to skip headings and other unwanted data.
If you wish to only import certain lines, eneter the start-end line numbers (2-20)



Dash For Code-Remark
When the Code field is read, it will be checked for the presence of a dash, if found the field will be split into two parts. The part before the dash is placed into the code field, the part after the dash will be placed into the remark field.

Use Code Library
Check this box to enable code translation and string formation.
See Form Strings by Code Library for details

Check Pt Codes
Check this box to force all codes to be checked against the library.
An error message will be displayed for any code found which is not in the library.

Form Strings/Pts - and Point Symbolisation
Check this box to automatically form strings according to the rules in the code library.
It will also check points against the Points symbol library and assign symbols, layer, colour etc to those that match.

This section describes how the Code Processing is done.

Library Code File
Enter the library code filename, usually a .CSV file.
If this is left blank, the XML config file will be used for the Code definitions.

Viewport Filter
When selected, only points within the viewport will be inserted into the job.
This option allows you to read VERY large CSV data files and only read in the part of the file that is of interest.

Insert Layer
You can select the layer for the imported points.
Note that this layer will not be used if Point Symbolisation requires a different layer.

Renumber Imported Points
Tick this box to Renumber the imported points to a different points range.

Insert Point
Allows you to set the first point number for the new points.
The default value is higher than the highest job point number, rounded to next 1000.

Overwrite Existing Points
Tick this box to allow imported points to overwrite existing points with the same number.
If unticked, the clashing imported point will be given a new (currently unused) point number usinf 'Insert Point' number.

Read Blank Attributes
Tick this to import Attributes even if the field is blank.

Trial Run
Tick to read the file but not actually insert the points.
This allow you to detect point clashes without actually importing the data.

Point Attribute Names
There are three ways to set the Attributes Names:
  1. Start Line > 1 - Use fields in line 1 as attribute names for each column
  2. In Template file set field Contents to 'Attribute' and enter the Attribute Name
  3. Have data field in the format 'name=value' or 'name:value'
  4. If no name can be found it will set the name to 'Att5' where 5 is the column number

See CSV Template File format for more details.

Refer also to Advanced Settings.

Non ASCII Files

The Import CSV File option can import non-ASCII files.
See UTF Files for more details.